Excel file save error: Someone else is working in <file> right now. Please try again later.

When trying to save a modified Excel file, which has been opened from a network share, our users are receiving the following message:

Someone else is working in "\\domain.com\users\username\Document.xls" right now. Please try again later.

The clients that have been affected are Windows 7 clients, and the DFS share is being served from a Windows 2012 server. I have already confirmed that DFS replication has not been enabled, so it isn't trying to lock files for replication. I have also disabled any real-time scanning that is occurring on the client to make sure that the AV software wasn't locking the files. I did notice when viewing the list of Open Files from the server's Computer Management console that when a users experiences this issue the file appears to be opened 4 times. Three times it shows that it was opened in Read mode and the 4th instance shows an Open Mode of Write. Typically, a file which is working correctly should just show one instance with the Open Mode of Read+Write. None of these open instances are temporary files preceded with a ~.

Any thoughts?


  • Edited by TechCheez Monday, June 30, 2014 3:35 PM
June 30th, 2014 2:15pm

Hi,

Does the issue occur in other operation system? Which Office version are you using? Have you ever tried to test with word document, PPT file or txt file?

Based on your description, the issue may be caused by the same file open multiple time in computer management on SQL server. The user probably has User Access Control (UAC) enabled on the machine and it is not letting him overwrite the existing copy of the file because she does not have it open in administrator mode. UAC will block overwriting (saving) the existing file without Administrative privileges and it will automatically open the save as dialog so you can save with a different name and if you click save without changing the name at the point, it tries to save as a new file over the existing file and it can't because the file is open.

I recommend you check the user's permission (Which showed in Computer Management console) and end the Excel file instance in the task manager of the user's client.

Also, we may try the workaround: Save it to local drive(like drive c:) and then copy it to DFS.

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Free Windows Admin Tool Kit Click here and download it now
July 1st, 2014 2:28am

Here is some tips on how to troubleshoot errors when you save Excel files.

http://www.repair-corrupt-files.blogspot.in/2014/06/how-to-fix-issues-with-excel-file-save.html

July 2nd, 2014 9:36am


Hi,
I'm marking the reply as answer as there has been no update for a couple of days.
If you come back to find it doesn't work for you, please reply to us and unmark the answer.

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Free Windows Admin Tool Kit Click here and download it now
July 8th, 2014 1:16am

The issue only occurs when opening the Excel file from the network. It does not happen when opening the file from a local drive. All of the users have Modify permissions on the network files which are experiencing the issue. We are running Office 2013 with the latest updates. As stated above, I have only noticed this on Windows 7 clients so far.

Based on your description, the issue may be caused by the same file open multiple time in computer management on SQL server.

I'm not sure where a SQL comes into the equation, this is a file server and is not running SQL at all.

July 9th, 2014 1:33pm

Did you ever fix this problem....I am having the same problem except my users have full permissions this only occurs on a network drive
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2014 9:50pm

I am having the same issue. Seems to be files over 50MB. 
March 23rd, 2015 11:58am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics